SELECT distinct MONTHNAME(dataField)"MONTH",YEAR(dataField)"DUE------", CONCAT( "/" , 'Demographic', "/" ) As "Demographic", demo.first_name "Patient", demo.last_name "Name", dataField "EDC", concat(p.last_name,',',p.first_name,'(',p.provider_no,')') "Provider" FROM measurements, demographic demo, provider p WHERE type ="EDC" AND dataField BETWEEN "{first_date}" AND "{second_date}" AND demo.patient_status = 'AC' AND demographicNo =demo.demographic_no AND p.provider_no =demo.provider_no AND dateEntered in (SELECT max(dateEntered) group by demo.last_name,demo.first_name) order by dataField ;